package cn.zjitc.dao.impl;

import cn.zjitc.dao.UserDao;
import cn.zjitc.domain.User;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

public class UserDaoImpl implements UserDao {

    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public List<User> findAll() {
        return jdbcTemplate.query("select * from sys_user", new BeanPropertyRowMapper<>(User.class));
    }

    @Override
    public Long save(User user) {

        // 创建 PreparedStatementCreator
        PreparedStatementCreator creator = new PreparedStatementCreator() {
            @Override
            public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
                // 使用原始 jdbc 完成一个 PreparedStatement 的组件
                PreparedStatement preparedStatement = connection.prepareStatement("insert into sys_user values (?,?,?,?,?)", PreparedStatement.RETURN_GENERATED_KEYS);
                preparedStatement.setObject(1, null);
                preparedStatement.setString(2, user.getUsername());
                preparedStatement.setString(3, user.getEmail());
                preparedStatement.setString(4, user.getPassword());
                preparedStatement.setString(5, user.getPhoneNum());

                return preparedStatement;
            }
        };
        // 创建 keyHolder
        GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();


        jdbcTemplate.update(creator, keyHolder);

        // 获得生成的主键
        long userId = keyHolder.getKey().longValue();

        /*jdbcTemplate.update("insert into sys_user values (?,?,?,?,?)",
                null,
                user.getUsername(),
                user.getEmail(),
                user.getPassword(),
                user.getPhoneNum());*/

        return userId; // 返回当前保存用户的 id，该 id 是数据库自动生成的
    }

    @Override
    public void saveUserRoleRel(Long id, Long[] roleIds) {
        for (Long roleId : roleIds) {
            jdbcTemplate.update("insert into sys_user_role values (?,?)", id, roleId);
        }
    }

    @Override
    public void delUserRoleRel(Long[] userId) {
        jdbcTemplate.update("delete from sys_user_role where userId=?",userId);
    }

    @Override
    public void del(Long[] userId) {
        jdbcTemplate.update("delete from sys_user where id=?",userId);
    }
}
